/*
 Navicat Premium Dump SQL

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 80039 (8.0.39)
 Source Host           : 127.0.0.1:3306
 Source Schema         : webadmin

 Target Server Type    : MySQL
 Target Server Version : 80039 (8.0.39)
 File Encoding         : 65001

 Date: 02/03/2025 13:42:52
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for acl_permission
-- ----------------------------
DROP TABLE IF EXISTS `acl_permission`;
CREATE TABLE `acl_permission` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `parent_id` bigint DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `component` varchar(255) DEFAULT NULL,
  `order_num` int DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of acl_permission
-- ----------------------------
BEGIN;
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (1, 0, '系统配置', NULL, 'menu', NULL, NULL, 10, '2025-02-22 14:50:27', '2025-02-22 14:50:31');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (2, 1, '参数设置', NULL, 'menu', NULL, NULL, 10, '2025-02-22 14:50:56', '2025-02-22 14:50:59');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (6, 1, '聚比特积分', 'bitpoint:query', 'menu', NULL, NULL, 10, '2025-02-27 10:00:06', '2025-02-27 10:46:42');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (7, 0, '权限设置', 'acl', 'menu', NULL, NULL, 10, '2025-02-27 10:03:44', '2025-02-27 10:03:44');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (8, 7, '登录用户管理', 'acluser', 'menu', NULL, NULL, 10, '2025-02-27 10:04:21', '2025-02-27 10:04:21');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (9, 7, '角色管理', 'aclrole', 'menu', NULL, NULL, 10, '2025-02-27 10:06:11', '2025-02-27 10:06:11');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (10, 7, '菜单管理', 'aclpermission', 'menu', NULL, NULL, 10, '2025-02-27 10:07:01', '2025-02-27 10:07:01');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (11, 8, '添加用户', 'acluser:add', 'button', NULL, NULL, 10, '2025-02-27 11:01:19', '2025-02-27 11:01:19');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (12, 8, '修改用户', 'acluser:edit', 'button', NULL, NULL, 10, '2025-02-27 11:03:16', '2025-02-27 11:03:16');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (13, 8, '删除用户', 'acluser:delete', 'button', NULL, NULL, 10, '2025-02-27 11:03:35', '2025-02-27 11:03:35');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (14, 9, '添加角色', 'aclrole:add', 'button', NULL, NULL, 10, '2025-02-27 11:03:56', '2025-02-27 11:03:56');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (15, 9, '修改角色', 'aclrole:edit', 'button', NULL, NULL, 10, '2025-02-27 11:04:18', '2025-02-27 11:04:18');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (16, 9, '删除角色', 'aclrole:delete', 'button', NULL, NULL, 10, '2025-02-27 11:04:38', '2025-02-27 11:04:38');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (17, 8, '分配角色', 'acluser:role', 'button', NULL, NULL, 10, '2025-02-27 11:05:12', '2025-02-27 11:05:12');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (18, 9, '分配菜单', 'aclrole:permission', 'button', NULL, NULL, 10, '2025-02-27 11:12:01', '2025-02-27 11:12:01');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (19, 10, '添加菜单', 'aclpermission:add', 'button', NULL, NULL, 10, '2025-02-27 11:12:32', '2025-02-27 11:12:32');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (20, 10, '修改菜单', 'aclpermission:edit', 'button', NULL, NULL, 10, '2025-02-27 11:12:52', '2025-02-27 11:12:52');
INSERT INTO `acl_permission` (`id`, `parent_id`, `name`, `code`, `type`, `icon`, `component`, `order_num`, `create_time`, `update_time`) VALUES (21, 10, '删除菜单', 'aclpermission:delete', 'button', NULL, NULL, 10, '2025-02-27 11:13:19', '2025-02-27 11:13:19');
COMMIT;

-- ----------------------------
-- Table structure for acl_role
-- ----------------------------
DROP TABLE IF EXISTS `acl_role`;
CREATE TABLE `acl_role` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `role` varchar(255) DEFAULT NULL COMMENT '角色名称',
  `mark` varchar(255) DEFAULT NULL COMMENT '角色描述',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of acl_role
-- ----------------------------
BEGIN;
INSERT INTO `acl_role` (`id`, `role`, `mark`, `create_time`, `update_time`) VALUES (1, 'admin', '管理员角色', '2025-02-22 14:49:44', '2025-02-22 14:49:47');
INSERT INTO `acl_role` (`id`, `role`, `mark`, `create_time`, `update_time`) VALUES (4, 'BB', 'bbb2', '2025-02-28 13:30:50', '2025-02-28 13:30:55');
INSERT INTO `acl_role` (`id`, `role`, `mark`, `create_time`, `update_time`) VALUES (5, 'CCC', 'c', '2025-02-28 13:31:07', '2025-02-28 13:31:07');
COMMIT;

-- ----------------------------
-- Table structure for acl_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `acl_role_permission`;
CREATE TABLE `acl_role_permission` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `role_id` bigint NOT NULL,
  `permission_id` bigint NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of acl_role_permission
-- ----------------------------
BEGIN;
INSERT INTO `acl_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `update_time`) VALUES (3, 5, 8, '2025-02-28 14:04:10', '2025-02-28 14:04:10');
INSERT INTO `acl_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `update_time`) VALUES (4, 5, 11, '2025-02-28 14:04:10', '2025-02-28 14:04:10');
INSERT INTO `acl_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `update_time`) VALUES (5, 5, 12, '2025-02-28 14:04:10', '2025-02-28 14:04:10');
INSERT INTO `acl_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `update_time`) VALUES (6, 5, 13, '2025-02-28 14:04:10', '2025-02-28 14:04:10');
INSERT INTO `acl_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `update_time`) VALUES (7, 5, 17, '2025-02-28 14:04:10', '2025-02-28 14:04:10');
INSERT INTO `acl_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `update_time`) VALUES (8, 5, 14, '2025-02-28 14:04:10', '2025-02-28 14:04:10');
INSERT INTO `acl_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `update_time`) VALUES (9, 5, 15, '2025-02-28 14:04:10', '2025-02-28 14:04:10');
INSERT INTO `acl_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `update_time`) VALUES (10, 5, 19, '2025-02-28 14:04:10', '2025-02-28 14:04:10');
INSERT INTO `acl_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `update_time`) VALUES (11, 5, 20, '2025-02-28 14:04:10', '2025-02-28 14:04:10');
INSERT INTO `acl_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `update_time`) VALUES (12, 4, 1, '2025-02-28 14:05:30', '2025-02-28 14:05:30');
INSERT INTO `acl_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `update_time`) VALUES (13, 4, 2, '2025-02-28 14:05:30', '2025-02-28 14:05:30');
INSERT INTO `acl_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `update_time`) VALUES (14, 4, 6, '2025-02-28 14:05:30', '2025-02-28 14:05:30');
COMMIT;

-- ----------------------------
-- Table structure for acl_user
-- ----------------------------
DROP TABLE IF EXISTS `acl_user`;
CREATE TABLE `acl_user` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `login_name` varchar(255) DEFAULT NULL COMMENT '登录名称',
  `login_password` varchar(255) DEFAULT NULL COMMENT '登录密码',
  `show_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '显示名称',
  `status` tinyint DEFAULT NULL COMMENT '状态 1：正常 0：冻结',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='后台管理用户表';

-- ----------------------------
-- Records of acl_user
-- ----------------------------
BEGIN;
INSERT INTO `acl_user` (`id`, `login_name`, `login_password`, `show_name`, `status`, `create_time`, `update_time`) VALUES (1, 'admin', '$2a$10$m.TMVSCxLwk6BYyNvqWLkOXwytiJF4cQR4aNANpIYuPX09fvMkNTm', '管理员', 1, '2025-02-22 14:48:33', '2025-02-22 14:48:37');
COMMIT;

-- ----------------------------
-- Table structure for acl_user_login_token
-- ----------------------------
DROP TABLE IF EXISTS `acl_user_login_token`;
CREATE TABLE `acl_user_login_token` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `uid` bigint NOT NULL,
  `token` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of acl_user_login_token
-- ----------------------------
BEGIN;
INSERT INTO `acl_user_login_token` (`id`, `uid`, `token`, `create_time`, `update_time`) VALUES (1, 1, '1c286fba-5407-40ec-845e-2f94d1407adc', '2025-02-25 22:48:27', '2025-02-25 22:48:27');
INSERT INTO `acl_user_login_token` (`id`, `uid`, `token`, `create_time`, `update_time`) VALUES (2, 1, 'c210e1d8-aad2-4df7-a9f0-a46d17345552', '2025-02-25 22:49:58', '2025-02-25 22:49:58');
INSERT INTO `acl_user_login_token` (`id`, `uid`, `token`, `create_time`, `update_time`) VALUES (3, 1, 'c19516cb-441b-4f39-98b1-43a2c4ca3d84', '2025-02-25 22:50:52', '2025-02-25 22:50:52');
INSERT INTO `acl_user_login_token` (`id`, `uid`, `token`, `create_time`, `update_time`) VALUES (4, 1, 'a771de12-a331-4bc1-a777-ae9ab070bcd6', '2025-02-27 11:23:21', '2025-02-27 11:23:21');
INSERT INTO `acl_user_login_token` (`id`, `uid`, `token`, `create_time`, `update_time`) VALUES (5, 1, '372d9813-a55a-4918-a115-9116a91b195b', '2025-02-27 11:23:50', '2025-02-27 11:23:50');
INSERT INTO `acl_user_login_token` (`id`, `uid`, `token`, `create_time`, `update_time`) VALUES (6, 1, 'cd2dd3ff-a862-453b-9ee9-7d6a26d8c227', '2025-02-27 11:25:12', '2025-02-27 11:25:12');
COMMIT;

-- ----------------------------
-- Table structure for acl_user_role
-- ----------------------------
DROP TABLE IF EXISTS `acl_user_role`;
CREATE TABLE `acl_user_role` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `role_id` bigint NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of acl_user_role
-- ----------------------------
BEGIN;
INSERT INTO `acl_user_role` (`id`, `user_id`, `role_id`, `create_time`, `update_time`) VALUES (1, 1, 1, '2025-02-22 14:49:57', '2025-02-22 14:50:00');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
